CREATE TABLE [dbo].[DonHang]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[MaKhachHang] [int] NOT NULL,
[GhiChu] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SoTien] [decimal] (18, 2) NOT NULL,
[NgayLapHD] [datetime] NULL CONSTRAINT [DF_DonHang_NgayLapHD] DEFAULT (getdate()),
[DonGia] [decimal] (18, 2) NULL CONSTRAINT [DF_DonHang_DonGia] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DonHang] ADD CONSTRAINT [PK_DonHang] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
